﻿IF object_id(N'dbo.TabExtMailAttachFiles', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[TabExtMailAttachFiles] (
        [FileID]         int          NOT NULL identity(1, 1),
        [MailID]         int          NOT NULL,
        [FileName]       nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
        [FileSize]       int          NULL,
        [FileAttribute]  int          NULL,
        [FileVisualPath] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
        [FileAddedDate]  datetime     NULL,

        CONSTRAINT [PK_TabExtMailAttachFiles] PRIMARY KEY CLUSTERED ([FileID] asc)
    );
END
GO
